﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CRMFramework;
using System.Collections;
using Newtonsoft.Json;
using CRMEntity;

namespace CRMBiz
{
    public static class SummaryHandler
    {
        public static DataSet GetSummaryList(int LoanID)
        {
            DataSet ds;
            try
            {
                var para = new[]{
                    DBhelper.SetParameter("@LoanID",LoanID)
                };
                string sbSql = "select crm_contact.* from am_loan1 inner join crm_contact on am_loan1.app_id=crm_contact.app_id where am_loan1.LoanID=@LoanID";
                ds = DBhelper.ExecuteDataset(sbSql, para);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return ds;
        }
    }
}
